ALTER TABLE XJEquipment ADD IsConsumables bit
GO
UPDATE XJEquipment SET IsConsumables = 0
GO
ALTER TABLE XJEquipment ALTER COLUMN IsConsumables bit NOT NULL
GO

ALTER TABLE XJEquipmentCategory ADD IsConsumables bit
GO
UPDATE XJEquipmentCategory SET IsConsumables = 0
GO
ALTER TABLE XJEquipmentCategory ALTER COLUMN IsConsumables bit NOT NULL
GO